
--卸车差异汇总
create external table jms_dm.dm_shipment_unloading_diff_summary_ht
(

    scantime            string comment '日期',
    agent_code          string comment '代理区编码',
    agent_name          string comment '代理区名称',
    fran_code           string comment '加盟商编码',
    fran_name           string comment '加盟商名称',
    network_code        string comment '网点编码',
    network_name        string comment '网点名称',
    shipment_no         string comment '任务单号',
    start_network_code  string comment '始发网点编码',
    start_network_name  string comment '始发网点名称',
    pre_network_code    string comment '上一站编码',
    pre_network_name    string comment '上一站编码名称',
    shipment_name       string comment '线路',
    count_type          string comment '网点类型',
    loading_bill_num    int comment '应卸票数',
    unloading_billl_num int comment '已卸票数',
    update_time         string comment '更新时间'
) comment '卸车差异汇总'
    PARTITIONED BY (dt STRING COMMENT '时间分区')
    STORED AS PARQUET
    LOCATION '/dw/hive/jms_dm.db/external/dm_shipment_unloading_diff_summary_ht'
    TBLPROPERTIES (
        'discover.partitions' = 'false',
        'parquet.column.index.access' = 'true'
        );